请问excel表中,判别两个单元格内数值范围后返回相应字符的公式_百度知 ...答:比如在C1单元格写入公式 =IF((A1<=50)*(B1<=200),"无",IF((A1>100)+(B1>500),"红",IF((A1>80)+(B1>350),"橙","黄")))或 =IF((A1>50)+(B1>200),IF((A1>100)+(B1>500),"红",IF((A1>80)+(B1>350),"橙","黄")),"无")如果改用OR和AND函数则公式就是 =IF(...
在excel中,当所选的单元格数值满足一系列数据中的一个时,则返回该满足...答:用lookup函数 如 =lookup(A1,{0,1,2,3,4,5,6,7},{"A","B","C","D","E","F","G","H"})注意,两组数据的个数要相同